SELECT 
	*
FROM [dbo].[Player] p
	join [dbo].[PlayerEnrollment] pe on (p.Player_ID = pe.player_id and p.[Type] in ('R') )
